SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/** Create Stored Procedures **/
CREATE PROCEDURE dbo.[DnnProduct_CDS_BillingConfigAdd]
	@Name nvarchar(256),
	@Description nvarchar(1024),
	@MonthlyMinimum decimal(18,2),
	@UnitBasedPricing bit,
	@TransactionFees nvarchar(max),
	@IncludedStorage bit,
	@StorageIncrement decimal(18,2),
	@StorageFee decimal(18,2),
	@BWSurcharge decimal(18,2),
	@BWBaseSize decimal(18,2),
	@BWAvgIncrement decimal(18,2)
AS
BEGIN
	INSERT INTO [DnnProduct_CDS_BillingConfig]
           ([Name],
           [Description],
           [MonthlyMinimum],
           [UnitBasedPricing],
           [TransactionFees],
           [IncludedStorage],
           [StorageIncrement],
           [StorageFee],
           [BWSurcharge],
           [BWBaseSize],
           [BWAvgIncrement])
     VALUES
           (@Name,
           @Description,
           @MonthlyMinimum,
           @UnitBasedPricing,
           @TransactionFees,
           @IncludedStorage,
           @StorageIncrement,
           @StorageFee,
           @BWSurcharge,
           @BWBaseSize,
           @BWAvgIncrement)

	SELECT SCOPE_IDENTITY()
END
GO
